<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="content-type">
  <title></title>
</head>
<body>

<?php 


// your database connection here

$dbConn=odbc_connect('EventDB','MyUser','Temp123');


echo "<select name='selectEvent'>";
$sql = mysql_query("SELECT EventName from Event");
while($result=mysql_fetch_array($query));
{
echo "<option name='id_list'>".$result['EventName']."</option>";
}
echo "</select>";

odbc_close($EventDB);
?>

<br>
</body>
</html>

